if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_KhuVuc_Insert]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_KhuVuc_Insert]
GO
CREATE PROC [sp_KhuVuc_Insert]
	@Ten					nvarchar(50),
	@Ghi_chu				nvarchar(100)

AS
BEGIN
	DECLARE @Ngay_cap_nhat_cuoi datetime
	SET @Ngay_cap_nhat_cuoi = getdate()
	INSERT INTO KhuVuc(
					Ten,
					Ghi_chu,
					Ngay_cap_nhat_cuoi
				)
	VALUES(				
		@Ten,
		@Ghi_chu,
		@Ngay_cap_nhat_cuoi
	)
END
